﻿ 
EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'cashTfrFlg'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'postScript'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'capitalTrans'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'groupTrans'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bankserailId'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'serialId'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'isForIndividual'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'oppBankType'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bankType'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bifCode'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'voucherNo'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'abs'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'uses'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'cdSignName'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'curCode'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'serialNo'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'transtime'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bal'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'cdSign'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'oppAccBank'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'oppAccNo'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'oppAccName'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'accName'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bankName'
GO

EXEC sys.sp_dropextendedproperty @name=N'MS_Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bankAcc'
GO

ALTER TABLE [dbo].[cust_queryaccdetail] DROP CONSTRAINT [DF_cust_queryaccdetail_fileflag]
GO

ALTER TABLE [dbo].[cust_queryaccdetail] DROP CONSTRAINT [DF_cust_queryaccdetail_glflag]
GO

/****** Object:  Table [dbo].[cust_queryReceipt]    Script Date: 2022/4/18 14:57:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cust_queryReceipt]') AND type in (N'U'))
DROP TABLE [dbo].[cust_queryReceipt]
GO

/****** Object:  Table [dbo].[cust_queryaccdetail]    Script Date: 2022/4/18 14:57:25 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cust_queryaccdetail]') AND type in (N'U'))
DROP TABLE [dbo].[cust_queryaccdetail]
GO

/****** Object:  Table [dbo].[cust_queryaccdetail]    Script Date: 2022/4/18 14:57:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[cust_queryaccdetail](
	[bankAcc] [nvarchar](50) NULL,
	[accName] [nvarchar](150) NULL,
	[oppAccName] [nvarchar](150) NULL,
	[oppAccNo] [nvarchar](50) NULL,
	[inamt] [decimal](28, 2) NULL,
	[outamt] [decimal](28, 2) NULL,
	[balance] [decimal](28, 2) NULL,
	[transtime] [nvarchar](50) NULL,
	[serialNo] [nvarchar](50) NULL,
	[exch] [nvarchar](50) NULL,
	[jybz] [nvarchar](500) NULL,
	[ctype] [nvarchar](150) NULL,
	[cbz] [nvarchar](150) NULL,
	[memo] [nvarchar](50) NULL,
	[serialId] [nvarchar](50) NULL,
	[glflag] [int] NULL,
	[inoid] [varchar](50) NULL,
	[createtime] [datetime] NULL,
	[iyear] [int] NULL,
	[imonth] [int] NULL,
	[pk] [varchar](50) NULL,
	[errmsg] [varchar](4000) NULL,
	[cflag] [varchar](50) NULL
) ON [PRIMARY]
GO


/****** Object:  Table [dbo].[cust_queryReceipt]    Script Date: 2022/4/18 14:57:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[cust_queryReceipt](
	[serialid] [nvarchar](50) NULL,
	[serialNo] [nvarchar](50) NULL,
	[downloadNo] [nvarchar](50) NULL,
	[downloadUrl] [nvarchar](512) NULL,
	[path] [nvarchar](512) NULL,
	[fileid] [nvarchar](512) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cust_queryaccdetail] ADD  CONSTRAINT [DF_cust_queryaccdetail_glflag]  DEFAULT ((0)) FOR [glflag]
GO

ALTER TABLE [dbo].[cust_queryaccdetail] ADD  CONSTRAINT [DF_cust_queryaccdetail_fileflag]  DEFAULT ((0)) FOR [fileflag]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bankAcc'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开户行名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bankName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'accName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对方户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'oppAccName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对方账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'oppAccNo'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对方开户行名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'oppAccBank'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收支方向0-收入 1-支出' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'cdSign'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'明细余额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bal'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'transtime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交易流水号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'serialNo'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'币种编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'curCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'cdSignName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用途' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'uses'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'摘要' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'abs'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'回单编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'voucherNo'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'银行类别代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bifCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'银行类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bankType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对方银行类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'oppBankType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对公、对私标志 0-对公，1-对私 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'isForIndividual'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'serialId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'银行流水号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'bankserailId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'集团内交易' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'groupTrans'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'资金划拨' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'capitalTrans'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交易备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'postScript'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现转标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cust_queryaccdetail', @level2type=N'COLUMN',@level2name=N'cashTfrFlg'
GO


